<?php
require("../../inc/header.php");

/*
		SoftName : EmpireBak Version 2010
		Author   : wm_chief
		Copyright: Powered by www.phome.net
*/

DoSetDbChar('utf8');
E_D("DROP TABLE IF EXISTS `ecs_bonus_type`;");
E_C("CREATE TABLE `ecs_bonus_type` (
  `type_id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `type_name` varchar(60) NOT NULL DEFAULT '',
  `type_money` decimal(10,2) NOT NULL DEFAULT '0.00',
  `send_type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `min_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `max_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `send_start_date` int(11) NOT NULL DEFAULT '0',
  `send_end_date` int(11) NOT NULL DEFAULT '0',
  `use_start_date` int(11) NOT NULL DEFAULT '0',
  `use_end_date` int(11) NOT NULL DEFAULT '0',
  `min_goods_amount` decimal(10,2) unsigned NOT NULL DEFAULT '0.00',
  `supplier_id` mediumint(8) unsigned NOT NULL DEFAULT '0' COMMENT '店铺id',
  PRIMARY KEY (`type_id`)
) ENGINE=MyISAM AUTO_INCREMENT=19 DEFAULT CHARSET=utf8");
E_D("replace into `ecs_bonus_type` values('18','订单红包','10.00','2','300.00','0.00','1418227200','1752249600','1418313600','1420992000','300.00','22');");
E_D("replace into `ecs_bonus_type` values('9','30元红包','30.00','0','0.00','0.00','1411056000','1413648000','1411056000','1445184000','200.00','1');");
E_D("replace into `ecs_bonus_type` values('11','65元订单红包','65.00','2','500.00','0.00','1411056000','1476806400','1411056000','1476806400','200.00','1');");
E_D("replace into `ecs_bonus_type` values('12','店铺商品红包','10.00','1','0.00','0.00','1411056000','1413648000','1411056000','1571414400','100.00','1');");
E_D("replace into `ecs_bonus_type` values('13','店铺红包20元','20.00','3','0.00','0.00','1411142400','1413734400','1411056000','1476892800','100.00','1');");

require("../../inc/footer.php");
?>